'use strict'

const pg = require('pg')

let psql = new pg.Pool({
    database: 'mxy',
    user: 'mxy',
    port: 5432,
    host:'127.0.0.1',
    password:'qwet12345',
    //最大使用5个客户端链接
    max:5
})

;(async ()=>{
    let tm =Date.now()
    //随机数字转成16进制并去掉前两位
    let id = `${Math.random().toString(16).substring(2)}`
    let sqltext = `INSERT INTO `
    + ` content(id, detail, title, add_time, update_time) `
    + ` VALUES($1, $2, $3, $4, $5)`

    let r = await psql.query(sqltext, [
        id, `测试内容: ${Math.random()}`, 'test',
        tm, tm
    ])
    console.log(r)
    //关闭连接
    psql.end()
})();

